EXCEL ADVANCE TRAINING FOR DATA SCIENCE
Welcome
Introduction
Why Excel and Relation to Data SCience
Understanding of concepts is more important than the tool, the operation of mathematical/scientific formulas go a long way to deeper knowledge of a concept.
The area of a square:
- What is it?
- What tools can you use?
From the above example it’s clear understanding the concept is
inconsequential to the tool, hence the reason data science with Excel.
Every tool has its on advantage over the other. The overarching question
Does the end justify the means or Means justify the end
Definition:
| ITEM | Description | |
|---|---|---|
| Data Science | In my own definition being able to extract information from different raw data sources and making sense out of it. Further extrapolation or predicting future information | |
| Excel | Microsoft Excel - Spreadsheet | |
| R | Programming Language for statistical analysis and automated execution | |
| Python | Programming Language for automation execution |
What we need
For this training will be looking at spreadsheets using the Microsoft Excel.
Numerous spread sheet application/software are available just to name a few:
- Microsoft Excel
- LibreOffice
- Google sheets
Some of the spreadsheets are paid for others a free and open source. Access can be both online (using your browsers i.e. Internet Explorer/Google Chrome/Mozilla) and offline (As a stand alone software installed on your computer/mobile phone)
Assumptions
Have some limited or little knowledge of Microsoft excel functions
e.g =sum(C1,C2), though not mandatory it makes it easier to
grasp concepts slightly faster.
Though if you remember the simple mathematics which we do everyday of summing and adding up money then you are good :).
Requirements
- Working computer (Laptop/Desktop)
- Access to internet once in a while to download a few resource materials
- Interest and desire to learn new concepts
Overview of our knowledge
- Operating and maneuvering on a PC/Laptop
- Basic knowledge of Ms Excel Interface
Teaching guide
- Mixed instructional guide, with the presentation but focused on getting more hard skills
- Prepare to write Excel formulas
- Engagements and practice on the fly
About the trainer
Just me but you can see you can get the details from qprop
Day 1
Navigating Ms Excel
Key Guiding Concepts
Vocabulary to be used.
Menu Bar
Menu Ribbon
Sheet
Formula Inputs placed inside cells to do various calculations
Rows Horizontal cells from
1to Maximum of1048576Columns Vertical cells from
Ato Maximum ofXFD